package com.jari.lg.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ViolationDetailTaskResultExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ViolationDetailTaskResultExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andJobinstanceidIsNull() {
            addCriterion("jobInstanceId is null");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidIsNotNull() {
            addCriterion("jobInstanceId is not null");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidEqualTo(String value) {
            addCriterion("jobInstanceId =", value, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidNotEqualTo(String value) {
            addCriterion("jobInstanceId <>", value, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidGreaterThan(String value) {
            addCriterion("jobInstanceId >", value, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidGreaterThanOrEqualTo(String value) {
            addCriterion("jobInstanceId >=", value, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidLessThan(String value) {
            addCriterion("jobInstanceId <", value, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidLessThanOrEqualTo(String value) {
            addCriterion("jobInstanceId <=", value, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidLike(String value) {
            addCriterion("jobInstanceId like", value, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidNotLike(String value) {
            addCriterion("jobInstanceId not like", value, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidIn(List<String> values) {
            addCriterion("jobInstanceId in", values, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidNotIn(List<String> values) {
            addCriterion("jobInstanceId not in", values, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidBetween(String value1, String value2) {
            addCriterion("jobInstanceId between", value1, value2, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andJobinstanceidNotBetween(String value1, String value2) {
            addCriterion("jobInstanceId not between", value1, value2, "jobinstanceid");
            return (Criteria) this;
        }

        public Criteria andEpolicenameIsNull() {
            addCriterion("ePoliceName is null");
            return (Criteria) this;
        }

        public Criteria andEpolicenameIsNotNull() {
            addCriterion("ePoliceName is not null");
            return (Criteria) this;
        }

        public Criteria andEpolicenameEqualTo(String value) {
            addCriterion("ePoliceName =", value, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameNotEqualTo(String value) {
            addCriterion("ePoliceName <>", value, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameGreaterThan(String value) {
            addCriterion("ePoliceName >", value, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameGreaterThanOrEqualTo(String value) {
            addCriterion("ePoliceName >=", value, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameLessThan(String value) {
            addCriterion("ePoliceName <", value, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameLessThanOrEqualTo(String value) {
            addCriterion("ePoliceName <=", value, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameLike(String value) {
            addCriterion("ePoliceName like", value, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameNotLike(String value) {
            addCriterion("ePoliceName not like", value, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameIn(List<String> values) {
            addCriterion("ePoliceName in", values, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameNotIn(List<String> values) {
            addCriterion("ePoliceName not in", values, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameBetween(String value1, String value2) {
            addCriterion("ePoliceName between", value1, value2, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicenameNotBetween(String value1, String value2) {
            addCriterion("ePoliceName not between", value1, value2, "epolicename");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeIsNull() {
            addCriterion("ePoliceCode is null");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeIsNotNull() {
            addCriterion("ePoliceCode is not null");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeEqualTo(String value) {
            addCriterion("ePoliceCode =", value, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeNotEqualTo(String value) {
            addCriterion("ePoliceCode <>", value, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeGreaterThan(String value) {
            addCriterion("ePoliceCode >", value, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeGreaterThanOrEqualTo(String value) {
            addCriterion("ePoliceCode >=", value, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeLessThan(String value) {
            addCriterion("ePoliceCode <", value, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeLessThanOrEqualTo(String value) {
            addCriterion("ePoliceCode <=", value, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeLike(String value) {
            addCriterion("ePoliceCode like", value, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeNotLike(String value) {
            addCriterion("ePoliceCode not like", value, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeIn(List<String> values) {
            addCriterion("ePoliceCode in", values, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeNotIn(List<String> values) {
            addCriterion("ePoliceCode not in", values, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeBetween(String value1, String value2) {
            addCriterion("ePoliceCode between", value1, value2, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andEpolicecodeNotBetween(String value1, String value2) {
            addCriterion("ePoliceCode not between", value1, value2, "epolicecode");
            return (Criteria) this;
        }

        public Criteria andPlatenumberIsNull() {
            addCriterion("plateNumber is null");
            return (Criteria) this;
        }

        public Criteria andPlatenumberIsNotNull() {
            addCriterion("plateNumber is not null");
            return (Criteria) this;
        }

        public Criteria andPlatenumberEqualTo(String value) {
            addCriterion("plateNumber =", value, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberNotEqualTo(String value) {
            addCriterion("plateNumber <>", value, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberGreaterThan(String value) {
            addCriterion("plateNumber >", value, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberGreaterThanOrEqualTo(String value) {
            addCriterion("plateNumber >=", value, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberLessThan(String value) {
            addCriterion("plateNumber <", value, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberLessThanOrEqualTo(String value) {
            addCriterion("plateNumber <=", value, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberLike(String value) {
            addCriterion("plateNumber like", value, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberNotLike(String value) {
            addCriterion("plateNumber not like", value, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberIn(List<String> values) {
            addCriterion("plateNumber in", values, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberNotIn(List<String> values) {
            addCriterion("plateNumber not in", values, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberBetween(String value1, String value2) {
            addCriterion("plateNumber between", value1, value2, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatenumberNotBetween(String value1, String value2) {
            addCriterion("plateNumber not between", value1, value2, "platenumber");
            return (Criteria) this;
        }

        public Criteria andPlatetypeIsNull() {
            addCriterion("plateType is null");
            return (Criteria) this;
        }

        public Criteria andPlatetypeIsNotNull() {
            addCriterion("plateType is not null");
            return (Criteria) this;
        }

        public Criteria andPlatetypeEqualTo(String value) {
            addCriterion("plateType =", value, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeNotEqualTo(String value) {
            addCriterion("plateType <>", value, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeGreaterThan(String value) {
            addCriterion("plateType >", value, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeGreaterThanOrEqualTo(String value) {
            addCriterion("plateType >=", value, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeLessThan(String value) {
            addCriterion("plateType <", value, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeLessThanOrEqualTo(String value) {
            addCriterion("plateType <=", value, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeLike(String value) {
            addCriterion("plateType like", value, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeNotLike(String value) {
            addCriterion("plateType not like", value, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeIn(List<String> values) {
            addCriterion("plateType in", values, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeNotIn(List<String> values) {
            addCriterion("plateType not in", values, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeBetween(String value1, String value2) {
            addCriterion("plateType between", value1, value2, "platetype");
            return (Criteria) this;
        }

        public Criteria andPlatetypeNotBetween(String value1, String value2) {
            addCriterion("plateType not between", value1, value2, "platetype");
            return (Criteria) this;
        }

        public Criteria andCartypeIsNull() {
            addCriterion("carType is null");
            return (Criteria) this;
        }

        public Criteria andCartypeIsNotNull() {
            addCriterion("carType is not null");
            return (Criteria) this;
        }

        public Criteria andCartypeEqualTo(String value) {
            addCriterion("carType =", value, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeNotEqualTo(String value) {
            addCriterion("carType <>", value, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeGreaterThan(String value) {
            addCriterion("carType >", value, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeGreaterThanOrEqualTo(String value) {
            addCriterion("carType >=", value, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeLessThan(String value) {
            addCriterion("carType <", value, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeLessThanOrEqualTo(String value) {
            addCriterion("carType <=", value, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeLike(String value) {
            addCriterion("carType like", value, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeNotLike(String value) {
            addCriterion("carType not like", value, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeIn(List<String> values) {
            addCriterion("carType in", values, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeNotIn(List<String> values) {
            addCriterion("carType not in", values, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeBetween(String value1, String value2) {
            addCriterion("carType between", value1, value2, "cartype");
            return (Criteria) this;
        }

        public Criteria andCartypeNotBetween(String value1, String value2) {
            addCriterion("carType not between", value1, value2, "cartype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeIsNull() {
            addCriterion("violationType is null");
            return (Criteria) this;
        }

        public Criteria andViolationtypeIsNotNull() {
            addCriterion("violationType is not null");
            return (Criteria) this;
        }

        public Criteria andViolationtypeEqualTo(String value) {
            addCriterion("violationType =", value, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeNotEqualTo(String value) {
            addCriterion("violationType <>", value, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeGreaterThan(String value) {
            addCriterion("violationType >", value, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeGreaterThanOrEqualTo(String value) {
            addCriterion("violationType >=", value, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeLessThan(String value) {
            addCriterion("violationType <", value, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeLessThanOrEqualTo(String value) {
            addCriterion("violationType <=", value, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeLike(String value) {
            addCriterion("violationType like", value, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeNotLike(String value) {
            addCriterion("violationType not like", value, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeIn(List<String> values) {
            addCriterion("violationType in", values, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeNotIn(List<String> values) {
            addCriterion("violationType not in", values, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeBetween(String value1, String value2) {
            addCriterion("violationType between", value1, value2, "violationtype");
            return (Criteria) this;
        }

        public Criteria andViolationtypeNotBetween(String value1, String value2) {
            addCriterion("violationType not between", value1, value2, "violationtype");
            return (Criteria) this;
        }

        public Criteria andKeyareaidIsNull() {
            addCriterion("keyAreaId is null");
            return (Criteria) this;
        }

        public Criteria andKeyareaidIsNotNull() {
            addCriterion("keyAreaId is not null");
            return (Criteria) this;
        }

        public Criteria andKeyareaidEqualTo(String value) {
            addCriterion("keyAreaId =", value, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidNotEqualTo(String value) {
            addCriterion("keyAreaId <>", value, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidGreaterThan(String value) {
            addCriterion("keyAreaId >", value, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidGreaterThanOrEqualTo(String value) {
            addCriterion("keyAreaId >=", value, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidLessThan(String value) {
            addCriterion("keyAreaId <", value, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidLessThanOrEqualTo(String value) {
            addCriterion("keyAreaId <=", value, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidLike(String value) {
            addCriterion("keyAreaId like", value, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidNotLike(String value) {
            addCriterion("keyAreaId not like", value, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidIn(List<String> values) {
            addCriterion("keyAreaId in", values, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidNotIn(List<String> values) {
            addCriterion("keyAreaId not in", values, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidBetween(String value1, String value2) {
            addCriterion("keyAreaId between", value1, value2, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andKeyareaidNotBetween(String value1, String value2) {
            addCriterion("keyAreaId not between", value1, value2, "keyareaid");
            return (Criteria) this;
        }

        public Criteria andJnccodeIsNull() {
            addCriterion("jncCode is null");
            return (Criteria) this;
        }

        public Criteria andJnccodeIsNotNull() {
            addCriterion("jncCode is not null");
            return (Criteria) this;
        }

        public Criteria andJnccodeEqualTo(String value) {
            addCriterion("jncCode =", value, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeNotEqualTo(String value) {
            addCriterion("jncCode <>", value, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeGreaterThan(String value) {
            addCriterion("jncCode >", value, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeGreaterThanOrEqualTo(String value) {
            addCriterion("jncCode >=", value, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeLessThan(String value) {
            addCriterion("jncCode <", value, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeLessThanOrEqualTo(String value) {
            addCriterion("jncCode <=", value, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeLike(String value) {
            addCriterion("jncCode like", value, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeNotLike(String value) {
            addCriterion("jncCode not like", value, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeIn(List<String> values) {
            addCriterion("jncCode in", values, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeNotIn(List<String> values) {
            addCriterion("jncCode not in", values, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeBetween(String value1, String value2) {
            addCriterion("jncCode between", value1, value2, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJnccodeNotBetween(String value1, String value2) {
            addCriterion("jncCode not between", value1, value2, "jnccode");
            return (Criteria) this;
        }

        public Criteria andJncnameIsNull() {
            addCriterion("jncName is null");
            return (Criteria) this;
        }

        public Criteria andJncnameIsNotNull() {
            addCriterion("jncName is not null");
            return (Criteria) this;
        }

        public Criteria andJncnameEqualTo(String value) {
            addCriterion("jncName =", value, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameNotEqualTo(String value) {
            addCriterion("jncName <>", value, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameGreaterThan(String value) {
            addCriterion("jncName >", value, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameGreaterThanOrEqualTo(String value) {
            addCriterion("jncName >=", value, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameLessThan(String value) {
            addCriterion("jncName <", value, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameLessThanOrEqualTo(String value) {
            addCriterion("jncName <=", value, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameLike(String value) {
            addCriterion("jncName like", value, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameNotLike(String value) {
            addCriterion("jncName not like", value, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameIn(List<String> values) {
            addCriterion("jncName in", values, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameNotIn(List<String> values) {
            addCriterion("jncName not in", values, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameBetween(String value1, String value2) {
            addCriterion("jncName between", value1, value2, "jncname");
            return (Criteria) this;
        }

        public Criteria andJncnameNotBetween(String value1, String value2) {
            addCriterion("jncName not between", value1, value2, "jncname");
            return (Criteria) this;
        }

        public Criteria andRoadidIsNull() {
            addCriterion("roadId is null");
            return (Criteria) this;
        }

        public Criteria andRoadidIsNotNull() {
            addCriterion("roadId is not null");
            return (Criteria) this;
        }

        public Criteria andRoadidEqualTo(String value) {
            addCriterion("roadId =", value, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidNotEqualTo(String value) {
            addCriterion("roadId <>", value, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidGreaterThan(String value) {
            addCriterion("roadId >", value, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidGreaterThanOrEqualTo(String value) {
            addCriterion("roadId >=", value, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidLessThan(String value) {
            addCriterion("roadId <", value, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidLessThanOrEqualTo(String value) {
            addCriterion("roadId <=", value, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidLike(String value) {
            addCriterion("roadId like", value, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidNotLike(String value) {
            addCriterion("roadId not like", value, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidIn(List<String> values) {
            addCriterion("roadId in", values, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidNotIn(List<String> values) {
            addCriterion("roadId not in", values, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidBetween(String value1, String value2) {
            addCriterion("roadId between", value1, value2, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadidNotBetween(String value1, String value2) {
            addCriterion("roadId not between", value1, value2, "roadid");
            return (Criteria) this;
        }

        public Criteria andRoadnameIsNull() {
            addCriterion("roadName is null");
            return (Criteria) this;
        }

        public Criteria andRoadnameIsNotNull() {
            addCriterion("roadName is not null");
            return (Criteria) this;
        }

        public Criteria andRoadnameEqualTo(String value) {
            addCriterion("roadName =", value, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameNotEqualTo(String value) {
            addCriterion("roadName <>", value, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameGreaterThan(String value) {
            addCriterion("roadName >", value, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameGreaterThanOrEqualTo(String value) {
            addCriterion("roadName >=", value, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameLessThan(String value) {
            addCriterion("roadName <", value, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameLessThanOrEqualTo(String value) {
            addCriterion("roadName <=", value, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameLike(String value) {
            addCriterion("roadName like", value, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameNotLike(String value) {
            addCriterion("roadName not like", value, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameIn(List<String> values) {
            addCriterion("roadName in", values, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameNotIn(List<String> values) {
            addCriterion("roadName not in", values, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameBetween(String value1, String value2) {
            addCriterion("roadName between", value1, value2, "roadname");
            return (Criteria) this;
        }

        public Criteria andRoadnameNotBetween(String value1, String value2) {
            addCriterion("roadName not between", value1, value2, "roadname");
            return (Criteria) this;
        }

        public Criteria andDatetimeIsNull() {
            addCriterion("datetime is null");
            return (Criteria) this;
        }

        public Criteria andDatetimeIsNotNull() {
            addCriterion("datetime is not null");
            return (Criteria) this;
        }

        public Criteria andDatetimeEqualTo(Date value) {
            addCriterion("datetime =", value, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeNotEqualTo(Date value) {
            addCriterion("datetime <>", value, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeGreaterThan(Date value) {
            addCriterion("datetime >", value, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("datetime >=", value, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeLessThan(Date value) {
            addCriterion("datetime <", value, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeLessThanOrEqualTo(Date value) {
            addCriterion("datetime <=", value, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeIn(List<Date> values) {
            addCriterion("datetime in", values, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeNotIn(List<Date> values) {
            addCriterion("datetime not in", values, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeBetween(Date value1, Date value2) {
            addCriterion("datetime between", value1, value2, "datetime");
            return (Criteria) this;
        }

        public Criteria andDatetimeNotBetween(Date value1, Date value2) {
            addCriterion("datetime not between", value1, value2, "datetime");
            return (Criteria) this;
        }

        public Criteria andKeyareanameIsNull() {
            addCriterion("keyAreaName is null");
            return (Criteria) this;
        }

        public Criteria andKeyareanameIsNotNull() {
            addCriterion("keyAreaName is not null");
            return (Criteria) this;
        }

        public Criteria andKeyareanameEqualTo(String value) {
            addCriterion("keyAreaName =", value, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameNotEqualTo(String value) {
            addCriterion("keyAreaName <>", value, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameGreaterThan(String value) {
            addCriterion("keyAreaName >", value, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameGreaterThanOrEqualTo(String value) {
            addCriterion("keyAreaName >=", value, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameLessThan(String value) {
            addCriterion("keyAreaName <", value, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameLessThanOrEqualTo(String value) {
            addCriterion("keyAreaName <=", value, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameLike(String value) {
            addCriterion("keyAreaName like", value, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameNotLike(String value) {
            addCriterion("keyAreaName not like", value, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameIn(List<String> values) {
            addCriterion("keyAreaName in", values, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameNotIn(List<String> values) {
            addCriterion("keyAreaName not in", values, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameBetween(String value1, String value2) {
            addCriterion("keyAreaName between", value1, value2, "keyareaname");
            return (Criteria) this;
        }

        public Criteria andKeyareanameNotBetween(String value1, String value2) {
            addCriterion("keyAreaName not between", value1, value2, "keyareaname");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}